package com.xuecheng.framework.utils;

/**
 * @author: gongfy
 * @create: 2020/8/21 11:48
 * @Description:
 */
public class TestDemo {

    public static void main(String[] args) {
//        SnowflakeIdWorker snowflakeIdWorker = new SnowflakeIdWorker(1,1);
//        for (int i = 0; i < 100; i++) {
//            System.out.println(snowflakeIdWorker.nextId());
//        }

        String str = "2019-10-30 10:11:46";
        str = str.substring(0,10);
        System.out.println(str);

        String sql = "select count(1) as num_ " +
                "from pay_t_voucher where province = ? and year = ? and payeeaccountno=? and payeeaccountbank =? and payeeaccountname=? and agencycode = ? and createtime like '"
                +str+"%' and setmodecode<>'1'";

        System.out.println(sql);

    }
}
